Implementation of Business intelligence in Know Your Customer (KYC) for credit card customers’ loan repayment status

Nowadays, the increasing technological improvements followed by data demand made businesses and organizations follow these to continue operating. The Know Your Customer (KYC) assessment is still manually done, growing amount of data, resulting in accumulation affecting time spend analyzing prospective applicant data. unavailability tools that can help review documents leads more timeconsuming KYC assessments. This paper aims create a Business Intelligence (BI) system financial analyze, process determine applicants’ eligibility who are willing get credit card services. may be utilized an enterprise operating sector follows procedure identify applicants require development BI systems predicted reduce spent validate application particularly banking or industry. study has designed three dimension tables fact table using Microsoft SQL Server 18 for warehouse. Pentaho Data Integration used ETL process, Tableau creates dashboard. dashboard contains general information loan repayment status applicant. Two pivot were created Excel summarize